﻿<?xml version="1.0" encoding="utf-8"?>
<xs:schema id="db" targetNamespace="http://tempuri.org/db.xsd" xmlns:mstns="http://tempuri.org/db.xsd" xmlns="http://tempuri.org/db.xsd" xmlns:xs="http://www.w3.org/2001/XMLSchema" xmlns:msdata="urn:schemas-microsoft-com:xml-msdata" xmlns:msprop="urn:schemas-microsoft-com:xml-msprop" attributeFormDefault="qualified" elementFormDefault="qualified">
  <xs:annotation>
    <xs:appinfo source="urn:schemas-microsoft-com:xml-msdatasource">
      <DataSource DefaultConnectionIndex="0" FunctionsComponentName="QueriesTableAdapter" Modifier="AutoLayout, AnsiClass, Class, Public" SchemaSerializationMode="IncludeSchema" xmlns="urn:schemas-microsoft-com:xml-msdatasource">
        <Connections>
          <Connection AppSettingsObjectName="Settings" AppSettingsPropertyName="dbConnectionString" ConnectionStringObject="" IsAppSettingsProperty="true" Modifier="Assembly" Name="dbConnectionString (Settings)" ParameterPrefix="@" PropertyReference="ApplicationSettings.WordsReminder.Properties.Settings.GlobalReference.Default.dbConnectionString" Provider="Microsoft.SqlServerCe.Client.3.5" />
        </Connections>
        <Tables>
          <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="WordsTableAdapter" GeneratorDataComponentClassName="WordsTableAdapter" Name="Words" UserDataComponentName="WordsTableAdapter">
            <MainSource>
              <DbSource ConnectionRef="dbConnectionString (Settings)" DbObjectName="Words" DbObjectType="Table" FillMethodModifier="Public" FillMethodName="Fill" GenerateMethods="Both" GenerateShortCommands="true" GeneratorGetMethodName="GetData" GeneratorSourceName="Fill" GetMethodModifier="Public" GetMethodName="GetData" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetData" UserSourceName="Fill">
                <DeleteCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="true">
                    <CommandText>DELETE FROM Words
WHERE     (Word = @word)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="word" ColumnName="Word" DataSourceName="Words" DataTypeServer="nvarchar(100)" DbType="String" Direction="Input" ParameterName="@word" Precision="0" ProviderType="NVarChar" Scale="0" Size="100" SourceColumn="Word" SourceColumnNullMapping="false" SourceVersion="Original" />
                    </Parameters>
                  </DbCommand>
                </DeleteCommand>
                <InsertCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="true">
                    <CommandText>INSERT INTO Words
                      (Word, Meaning, Reminding)
VALUES     (@word,@meaning,@remaining)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="word" ColumnName="Word" DataSourceName="Words" DataTypeServer="nvarchar(100)" DbType="String" Direction="Input" ParameterName="@word" Precision="0" ProviderType="NVarChar" Scale="0" Size="100" SourceColumn="Word" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="meaning" ColumnName="Meaning" DataSourceName="Words" DataTypeServer="nvarchar(400)" DbType="String" Direction="Input" ParameterName="@meaning" Precision="0" ProviderType="NVarChar" Scale="0" Size="400" SourceColumn="Meaning" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="remaining" ColumnName="Reminding" DataSourceName="Words" DataTypeServer="bit(1)" DbType="Boolean" Direction="Input" ParameterName="@remaining" Precision="0" ProviderType="Bit" Scale="0" Size="1" SourceColumn="Reminding" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </InsertCommand>
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="true">
                    <CommandText>SELECT     Word, Meaning, Reminding
FROM         Words</CommandText>
                    <Parameters />
                  </DbCommand>
                </SelectCommand>
                <UpdateCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="true">
                    <CommandText>UPDATE    Words
SET              Word = @newWord, Meaning = @newMeaning, Reminding = @newReminding
WHERE     (Word = @currWord)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="newWord" ColumnName="Word" DataSourceName="Words" DataTypeServer="nvarchar(100)" DbType="String" Direction="Input" ParameterName="@newWord" Precision="0" ProviderType="NVarChar" Scale="0" Size="100" SourceColumn="Word" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="newMeaning" ColumnName="Meaning" DataSourceName="Words" DataTypeServer="nvarchar(400)" DbType="String" Direction="Input" ParameterName="@newMeaning" Precision="0" ProviderType="NVarChar" Scale="0" Size="400" SourceColumn="Meaning" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="newReminding" ColumnName="Reminding" DataSourceName="Words" DataTypeServer="bit(1)" DbType="Boolean" Direction="Input" ParameterName="@newReminding" Precision="0" ProviderType="Bit" Scale="0" Size="1" SourceColumn="Reminding" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="currWord" ColumnName="Word" DataSourceName="Words" DataTypeServer="nvarchar(100)" DbType="String" Direction="Input" ParameterName="@currWord" Precision="0" ProviderType="NVarChar" Scale="0" Size="100" SourceColumn="Word" SourceColumnNullMapping="false" SourceVersion="Original" />
                    </Parameters>
                  </DbCommand>
                </UpdateCommand>
              </DbSource>
            </MainSource>
            <Mappings>
              <Mapping SourceColumn="Word" DataSetColumn="Word" />
              <Mapping SourceColumn="Meaning" DataSetColumn="Meaning" />
              <Mapping SourceColumn="Reminding" DataSetColumn="Reminding" />
            </Mappings>
            <Sources>
              <DbSource ConnectionRef="dbConnectionString (Settings)" DbObjectName="Words" DbObjectType="Table" FillMethodModifier="Public" FillMethodName="FillByRemainingType" GenerateMethods="Both" GenerateShortCommands="true" GeneratorGetMethodName="GetDataByRemainingType" GeneratorSourceName="FillByRemainingType" GetMethodModifier="Public" GetMethodName="GetDataByRemainingType" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetDataByRemainingType" UserSourceName="FillByRemainingType">
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="true">
                    <CommandText>SELECT     Word, Meaning, Reminding
FROM         Words
WHERE     (Reminding = @remaining)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="remaining" ColumnName="Reminding" DataSourceName="Words" DataTypeServer="bit(1)" DbType="Boolean" Direction="Input" ParameterName="@remaining" Precision="0" ProviderType="Bit" Scale="0" Size="1" SourceColumn="Reminding" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </SelectCommand>
              </DbSource>
              <DbSource ConnectionRef="dbConnectionString (Settings)" DbObjectName="Words" DbObjectType="Table" FillMethodModifier="Public" FillMethodName="FillByTopCount" GenerateMethods="Both" GenerateShortCommands="true" GeneratorGetMethodName="GetDataByTopCount" GeneratorSourceName="FillByTopCount" GetMethodModifier="Public" GetMethodName="GetDataByTopCount" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetDataByTopCount" UserSourceName="FillByTopCount">
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="true">
                    <CommandText>SELECT     TOP (5) *
FROM         Words
WHERE     Word LIKE @likeStr
ORDER BY Word</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="likeStr" ColumnName="Word" DataSourceName="Words" DataTypeServer="nvarchar(100)" DbType="String" Direction="Input" ParameterName="@likeStr" Precision="0" ProviderType="NVarChar" Scale="0" Size="100" SourceColumn="Word" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </SelectCommand>
              </DbSource>
              <DbSource ConnectionRef="dbConnectionString (Settings)" DbObjectType="Unknown" GenerateShortCommands="true" GeneratorSourceName="GetRemindedCount" Modifier="Public" Name="GetRemindedCount" QueryType="Scalar" ScalarCallRetval="System.Int32, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetDataBy3" UserSourceName="GetRemindedCount">
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="true">
                    <CommandText>SELECT        COUNT(*) AS Expr1
FROM            Words
WHERE        (Reminding = 1)</CommandText>
                    <Parameters />
                  </DbCommand>
                </SelectCommand>
              </DbSource>
              <DbSource ConnectionRef="dbConnectionString (Settings)" DbObjectType="Unknown" GenerateShortCommands="true" GeneratorSourceName="GetTotalCount" Modifier="Public" Name="GetTotalCount" QueryType="Scalar" ScalarCallRetval="System.Int32, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetDataBy2" UserSourceName="GetTotalCount">
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="true">
                    <CommandText>SELECT        COUNT(*) AS Expr1
FROM            Words</CommandText>
                    <Parameters />
                  </DbCommand>
                </SelectCommand>
              </DbSource>
              <DbSource ConnectionRef="dbConnectionString (Settings)" DbObjectType="Unknown" GenerateShortCommands="true" GeneratorGetMethodName="GetDataBy1" GeneratorSourceName="WordAndRemainingExists" Modifier="Public" Name="WordAndRemainingExists" QueryType="Scalar" ScalarCallRetval="System.Int32, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetDataBy" UserSourceName="WordAndRemainingExists">
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="true">
                    <CommandText>SELECT     COUNT(*) AS Expr1
FROM         Words
WHERE     (Word = @word) AND (Reminding = @remaining)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="word" ColumnName="Word" DataSourceName="Words" DataTypeServer="nvarchar(100)" DbType="String" Direction="Input" ParameterName="@word" Precision="0" ProviderType="NVarChar" Scale="0" Size="100" SourceColumn="Word" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="remaining" ColumnName="Reminding" DataSourceName="Words" DataTypeServer="bit(1)" DbType="Boolean" Direction="Input" ParameterName="@remaining" Precision="0" ProviderType="Bit" Scale="0" Size="1" SourceColumn="Reminding" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </SelectCommand>
              </DbSource>
              <DbSource ConnectionRef="dbConnectionString (Settings)" DbObjectType="Unknown" GenerateShortCommands="true" GeneratorSourceName="WordExists" Modifier="Public" Name="WordExists" QueryType="Scalar" ScalarCallRetval="System.Int32, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetDataBy1" UserSourceName="WordExists">
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="true">
                    <CommandText>SELECT     COUNT(*) AS Expr1
FROM         Words
WHERE     (Word = @word)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="word" ColumnName="Word" DataSourceName="Words" DataTypeServer="nvarchar(100)" DbType="String" Direction="Input" ParameterName="@word" Precision="0" ProviderType="NVarChar" Scale="0" Size="100" SourceColumn="Word" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </SelectCommand>
              </DbSource>
            </Sources>
          </TableAdapter>
        </Tables>
        <Sources />
      </DataSource>
    </xs:appinfo>
  </xs:annotation>
  <xs:element name="db" msdata:IsDataSet="true" msdata:UseCurrentLocale="true" msprop:EnableTableAdapterManager="true" msprop:Generator_DataSetName="db" msprop:Generator_UserDSName="db">
    <xs:complexType>
      <xs:choice minOccurs="0" maxOccurs="unbounded">
        <xs:element name="Words" msprop:Generator_UserTableName="Words" msprop:Generator_RowEvArgName="WordsRowChangeEvent" msprop:Generator_TableVarName="tableWords" msprop:Generator_TablePropName="Words" msprop:Generator_RowDeletingName="WordsRowDeleting" msprop:Generator_RowChangingName="WordsRowChanging" msprop:Generator_RowDeletedName="WordsRowDeleted" msprop:Generator_TableClassName="WordsDataTable" msprop:Generator_RowChangedName="WordsRowChanged" msprop:Generator_RowEvHandlerName="WordsRowChangeEventHandler" msprop:Generator_RowClassName="WordsRow">
          <xs:complexType>
            <xs:sequence>
              <xs:element name="Word" msprop:Generator_ColumnVarNameInTable="columnWord" msprop:Generator_ColumnPropNameInRow="Word" msprop:Generator_ColumnPropNameInTable="WordColumn" msprop:Generator_UserColumnName="Word">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="100" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="Meaning" msprop:Generator_ColumnVarNameInTable="columnMeaning" msprop:Generator_ColumnPropNameInRow="Meaning" msprop:Generator_ColumnPropNameInTable="MeaningColumn" msprop:Generator_UserColumnName="Meaning" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="400" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="Reminding" msprop:Generator_ColumnVarNameInTable="columnReminding" msprop:Generator_ColumnPropNameInRow="Reminding" msprop:Generator_ColumnPropNameInTable="RemindingColumn" msprop:Generator_UserColumnName="Reminding" type="xs:boolean" />
            </xs:sequence>
          </xs:complexType>
        </xs:element>
      </xs:choice>
    </xs:complexType>
    <xs:unique name="Constraint1" msdata:PrimaryKey="true">
      <xs:selector xpath=".//mstns:Words" />
      <xs:field xpath="mstns:Word" />
    </xs:unique>
  </xs:element>
</xs:schema>